Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P Q R S T U V W Y Z

## Symbols

  $AGGMAP property, 6
  $AGGREGATE_FORCECALC property, 6
  $AGGREGATE_FORCEORDER property, 6, 6
  $AGGREGATE_FROM property, 6, 6
  $AGGREGATE_FROMVAR property, 6
  $ALLOCMAP property, 6
  $COUNTVAR property, 6
  $DEFAULT_LANGUAGE property, 6
  $NATRIGGER property
    calling recursively, 20
    executing simultaneously, 24
  $STORETRIGGERVAL property, 6
  $VARCACHE property, 6
  % wildcard, 2.8.6.1
  & operator, 2.10
  = command, 21
    event, 24, 24, 24
    introduced, 2.3, 2.3
    trigger, 24, 24, 24
    with QDR, 2.12.2.2
  _ wildcard, 2.8.6.1

## A

  abbreviating OLAP DML statements, 5
  ABS function, 2.8.3.1, 6
  ACQUIRE command, 6
  ACROSS command, 6
  ACROSS keyword, 21
    $AGGREGATE_FROMVAR property, 6, 6
    = command, 21
    FETCH command, 12
    FILEREAD command, 13, 22
    FILEVIEW command, 13
    HEADING command, 14
    models, 4.4.2.2
    REPORT command, 20
    ROW command, 21
    SQL FETCH command, 22
    SQL SELECT command, 22
  ADD_MONTHS command, 6
  Aggcount variables, 6, 9, 10, 10
  AGGINDEX statement, 6
  AGGMAP ADD model command, 6
  AGGMAP command, 6
  AGGMAP property
    See $AGGMAP property
  AGGMAP REMOVE model command, 6
  AGGMAP SET command, 6
  AGGMAPINFO command, 7
  aggmaps
    compiling, 3.1.2
    defining, 10
    deleting, 10
    models in, 6
  Aggregate Advisor, 3.1.3, 6, 6, 6, 6
  AGGREGATE command, 7
  AGGREGATE function, 7
  AGGREGATE_FROM property
    See $AGGREGATE_FROM property
  AGGREGATE_FROMVAR property
    See $AGGREGATE_FROMVAR property
  aggregating data, 23
    caching, 24
    formulas to, 7
    on-the-fly, 3.1.3
    partitioned variables, 7, 19
    precomputing, 3.1.3
    specifying a relation for, 6
    using an Aggcount variable, 6
  AGGREGATION function, 7
  aggregation functions, A.3.10.5
  algorithm for composite values, 21
  alias dimensions
    defining, 10
    deleting, 10, 10, 10, 10
    limiting, 10
    maintaining, 10
    populating, 10
  aliases
    for analytic workspace, 2.4.1
    for analytic workspaces, 8
    for dimensions, 10
    workspace See workspace alias
  ALLCOMPILE program, 7
  ALLOCATE command, 7
  allocating data, 3.2.1, 23
  ALLOCERRLOGFORMAT option, 7
  ALLOCERRLOGHEADER option, 7
  ALLOCMAP command, 7
  ALLOCMAP property
    See $ALLOCMAP property
  ALLSTAT command, 7
  ampersand &(amp;) operator, 2.10
  ampersand substitution
    example of, 2.10
    prevents compiling, 5.3.2
    program arguments and, 5.2.2.3
    QDR with, 2.12.2.6
    using to pass arguments, 5.2.2.3, 16
  analytic workspaces
    aliases, 2.4.1, 2.4.1, 8
    content summary, displaying, 8
    current, 2.4.1
    current workspace, 2.4.1
    deleting objects, 10
    exclusive, 8
    exporting, 5.6.6
    importing, 5.6.6
    name, 2.4.1
    objects, defining in a program, 5.3.2
    obtaining information about, 8
    partitioning, 8
    permission programs, 5.6.1, 5.6.1.1
    read-only, 8
    read/write, 8
    sharing, 8
    starting, 8
    updating, 24
    waiting to attach, 8
  AND operator, 2.3.2, 2.3.2, 2.3.2
  ANTILOG function, 7
  ANTILOG10 function, 7
  ANY function, 7
  arc tangent calculation, 8
  ARCCOS function, 7
  ARCSIN function, 8
  ARCTAN function, 8
  ARCTAN2 function, 8
  ARG command
    See ARGUMENT command
  ARG function, 8
  ARGCOUNT function, 8
  ARGFR function, 8
  ARGS function, 8
  ARGUMENT command, 8
  arguments, 8
    in user-defined functions, 5.2.1
    passing as text, 5.2.2.3, 16
    passing to a program, 8, 8, 8, 8, 8
    using ampersand substitution with, 5.2.2.3
  ASCII function, 8
  Assign event, 24
  assigning values
    OLAP DML statements, A.3.6
    SET, 21
    SET1, 21
  assignment operator
    See = command
  assignment statements
    event, 24, 24, 24
    SET, 21
    SET1, 21
    trigger, 24, 24, 24
    with QDR, 2.12.2.2
  authentication, 19
    encrypting text expressions, 19
    within Oracle OLAP, 19
  average
    calculating, 8
    moving, 18
  AVERAGE function, 8
  AW ALIASLIST command, 8
  AW ATTACH command, 8
  AW command, 8
    events, 24
    triggers, 24
  AW CREATE command, 8
  AW DELETE command, 8
  AW DETACH command, 8
  AW function, 8
  AW LIST command, 8
  AW SEGMENTSIZE command, 8
  AWDESCRIBE program, 8
  AWWAITTIME option, 8

## B

  BACK function, 7, 7, 8, A.3.12, A.3.13
  BADLINE option, 5.4.2, 8
  base dimensions
    finding values of, 8, 15
  BASEDIM function
    base dimensions
      identifying, 8
  BASEVAL function, 8
  BEGINDATE, 8
  BITAND function, 8
  bits, adding, 8
  BLANK command, 8
  blank lines in reports, 8
  blanks in text values, stripping, 8
  BLANKSTRIP function, 8
  BMARGIN option, 8
  Boolean constants, 2.2.3, 2.8
  Boolean data type, 2.2.3
  Boolean expressions
    creating, 2.8.1
    defined, 2.8
    example of, 2.8.1
    involving NA values, 2.8.2
    operators, 2.3.2, 2.3.2
    values, 2.8
  Boolean operators
    evaluation order, 2.3.2, 2.3.2
    table of, 2.3.2, 2.3.2
  Boolean values, 18
    spelling of false values, 18
    spelling of true values, 24
  branching in programs, 8, 9, 14, 14, 16, 23
  BREAK command, 8
  bucket numbers, retrieving, 24
  build number, 11
  byte manipulation functions, 8, 12, 13, 15, 15, 17, 18, 20, 20
  bytes, 13
    finding location in text expression, 13
    functions for, A.3.8.1, A.3.8.2, A.3.8.3

## C

  CACHE command, 24
  CACHE statement, 6, 6, 6, 6, 6, 6
  caches
    See OLAP session cache
  calculated members
    adding to dimension, 16
    identifying, 15
  calculating a linear regression, 12, 20
  CALENDARWEEK option, 8
  CALL command, 8
  CALLTYPE function, 8, A.3.18.5
  capitalizing strings, 15
  carriage return (escape sequence), 2.2.2.2
  case conversion, 24
  case statement in programs, 23
  CATEGORIZE function, 8
  CDA command, 8
  CEIL function, 8
  CHANGEBYTES function, 8
  CHANGECHARS function, 8
  characters
    capitalizing, 15
    converting to uppercase, 24
    finding location in text expression, 13
    functions for, A.3.8.1, A.3.8.2, A.3.8.3
    representing as decimals, 2.2.2.2
    representing as hexadecimals, 2.2.2.2
    representing as Unicode, 2.2.2.2
    retrieving decimal representation, 8
  CHARLIST function, 8
  CHGDFN command, 9
  CHGDIMS function, 9
  CHILDLOCK statement, 7
  CLEANUP command
    See SQL CLEANUP command
  CLEAR command, 9
  CLOSE command
    See SQL CLOSE command
  COALESCE function, 9
  columns
    default width in reports, 9, 15
    getting value from a report column, 9
    headings in a report, 14
    in reports, 9
    multiline text, 12, 15, 15, 20, 20
  COLVAL function, 9
  COLWIDTH function, 9
  command sequence
    accessing previously executed commands, 20
    executing previously executed commands, 20
  COMMAS option, 9
  comments in programs, 5.2
  COMMIT command, 9
  comparing text data, 15, 16
  comparison operators, 2.3.2
  compilable objects, 9
  COMPILE command, 9
    example of, 9
  COMPILEMESSAGE option, 9
  COMPILEWARN option, 9
  compiling, 9, 9
    aggmaps, 3.1.2
    models, 4.3
    programs, 5.3
    SQL statements, 22
    suppressing error messages, 9
  composites
    base dimension values, 15
    changing to conjoint dimensions, 9
    defining, 10, 10
    deleting, 10, 10, 10, 10
    deleting values of, 16
    index algorithm, 21, 21
    limiting dimensions used by, 2.4.4.3
    maintaining, 16
    reporting, 20, 21
    showing a value, 21
    specifying value, 2.4.3.1
    statements for managing, A.3.15
    testing for a value, 15
    unnamed, 10
    using commands with, 2.4.4.3
  concat dimensions
    defining, 10
    deleting, 10, 10
    specifying value of, 2.4.3.2
  concat partitions, 10
  conditional execution of commands, 11
  conditional expressions, 2.9, 2.9
  conditional operators
    defined, 2.9
    example of, 2.9
  conjoint dimensions
    base dimension values, 15
    changing to composites, 9
    defining, 10
    deleting, 10, 10
  CONSIDER command, 9
  CONTEXT command, 5.2.4.6, 9
  CONTEXT function, 5.2.4.6, 9
  CONTINUE command, 9
  controlled sparsity, 10
  CONVERT function, 9
  converting
    decimal numbers to integers, 15
    values from one data type to another, 9
  COPYDFN command, 9
  copying definitions, 9
  CORRELATION function, 9
  COS function, 9
  COSH function, 9
  cosine calculation, 9, 9
  COUNT function, 9
  counting, 18
    lines in a text expression, 18
    number of true values, 9
  COUNTVAR property
    See $COUNTVAR property
  CUMSUM function, 9
  cumulative totals, 9, 21
  current
    analytic workspace, 2.4.1
    status See current status
  current directory, 8
  current outfile, 11, 19
  current status, 1.5.1.1, 1.5.1.1, 15, 16
  cursors, 22
    closing (SQL), 22
    defining (SQL), 22, 22
    importing (SQL), 22

## D

  data fetches (SQL), 22
  data types, 23, 23, 23
    converting, 1.3.2, 1.3.2, 1.3.2, 9, 23, 23, 23, A.3.2, A.3.2, A.3.3, A.3.5
    creating a report, 20, 21
    date, 2.2.4
    determining data type of an object, 19
    for variables, 10
    numeric, 2.2.1
    of expressions, 2.1.1
    of numeric expressions, 2.6, 2.6.1
    of user-defined function, 5.2.1
    qualifying data for expressions, 19
    restricting access, 19
    showing a single value, 21
    statements for converting, 1.3.2, 1.3.2, 1.3.2, A.3.2, A.3.2, A.3.3, A.3.5
    text, 2.2.2
    transferring from one format to another, 24
  data values
    accessing variable, 2.4.4.2
    numeric, 2.6
  DATABASE command
    name change, Preface
    See AW command
  DATABASE function
    name change, Preface
    See AW function
  date and time functions, A.3.9
  date conversion, 23, 23
  DATE data type, 2.2.4
  DATEFORMAT option, 9
  DATEORDER option, 9
  dates, 23, 23
    comparing with times, 2.8.5
    current, 23, 23
    functions, A.3.9
    in arithmetic expressions, 2.6.4
    in text expressions, 2.7.2
  DATETIME data type, 2.2.4, 2.7.2
  DAYABBRLEN option, 9
  DAYNAMES option, 9
  DAYOF function, 9
  DBDESCRIBE program
    name change, Preface
    See AWDESCRIBE program
  DBGOUTFILE command, 5.4.3, 9
    and ECHOPROMPT, 11
  DBWAITTIME option
    name change, Preface
    See AWWAITTIME option
  DDOF function, 9
  DEADLOCK statement, 7
  debugging, 8, 9, 11, 12, 17, 17, 19
    statements for, A.3.18.4
  debugging programs, 5.4
  decimal
    marker, 10
    places, 10
    places (displayed), 10
  DECIMAL data type, 2.2.1, 2.8.3.3
  decimal data types, comparing, 2.8.3.3
  decimal values, 10
    decimal marker for output, 10
    truncating to an integer, 15
  DECIMALCHAR option, 10
  DECIMALOVERFLOW option, 2.6.6, 10
  DECIMALS option, 2.8.3, 2.8.3.1, 10
  DECLARE CURSOR command
    See SQL DECLARE CURSOR command
  DECODE function, 10
  default outfile, 11, 19
  default relations, 2.4.3.3, 20
  default status list, 1.5.1.2
  DEFAULTAWSEGSIZE option, 10
  DEFAULTDBFSIZE option
    name change, Preface
    See DEFAULTAWSEGSIZE option
  DEFINE AGGMAP command, 10, 10
  DEFINE command, 10
    events, 24
    triggers, 24
  DEFINE COMPOSITE command, 10
  DEFINE DIMENSION ALIASOF command, 10
  DEFINE DIMENSION command, 10
  DEFINE FORMULA command, 10
  DEFINE MODEL command, 10
  DEFINE PARTITION TEMPLATE command, 10
  DEFINE PROGRAM command, 10
  DEFINE RELATION command, 10
  DEFINE SURROGATE command, 10, 10
  DEFINE VALUESET command, 10
  DEFINE VARIABLE command, 10
  DEFINE WORKSHEET command, 10
  defining
    aggmap objects, 10
    alias dimensions, 10
    analytic workspace objects, 10
    dimension alias, 10
    dimensions, 10
    formulas, 10
    partitions, 10
    programs, 10
    relations, 10, 10
    surrogates, 10
    valuesets, 10, 10
    variables, 10
    worksheet objects, 10
  definitions
    copying, 9
    creating, 10
    creating object properties, 19
    deleting, 10
    moving within NAME dimension, 18
    report of, 11, 13
    testing for, 11
  DELETE command, 10
    event, 24, 24
    trigger, 24, 24
  Delete event, 24
  deleting
    alias dimensions, 10
    composite values, 16
    composites, 10
    definitions, 10
    dimension alias, 10
    dimension values, 16, 16
    dimensions, 10
    formulas, 10
    models, 10
    objects, 10
    partition templates, 10
    partitions, 10
    programs, 10
    surrogates, 10
    triggers, 24, 24, 24
    valuesets, 10
  DEPRDECL function, 11
  DEPRDECLSW function, 11
  depreciation of assets, 11, 11, 11, 11
  DEPRSL function, 11
  DEPRSOYD function, 11
  DESCRIBE command, 11
  descriptions
    adding to a definition, 15
    deleting from a definition, 15
  dimension alias
    defining, 10
    deleting, 10, 10
  DIMENSION command, in a model, 17
  DIMENSION statement
    for aggregation, 6
    for allocation, 7
  dimension status, 1.5.1.1, 16, 22
    default, 1.5.1.2
    effect on expressions, 2.5.2
    null, 19
    of dimensions used by composites, 2.4.4.3
    restoring, 1.5.1.4, 5.2.4.2
    restoring current, 1.5.1.4
    saving current, 1.5.1.4
    saving current status, 1.5.1.4, 5.2.4.2
    status for managing, A.3.15
  dimension surrogates
    assigning values to, 21
    defining, 10
  dimension value
    checking current status list, 22, 22, 22, 22
    checking if in status, 15
    checking status for a value, 15
    counting related values, 23
    listing associated objects, 16
    listing values, 24
    null values, 19
    saving the status in a context, 9
    sorting the status list, 16, 21, 21
    testing for a value, 15
    using qualified data reference, 19
    using result of LIMIT command, 16
  dimension values
    checking if in status, 15
    comparing, 2.8.4
    counting related values, 23
    deleting values of, 16, 16
    latest value, 22
    number of values in status, 22
    retrieving current status list, 22
    returning first value in status, 22
    returning last value in status, 22
    setting the status of, 16
  dimensionality, changing in an expression, 9
  dimension-based equations, 4.1
  dimensions
    checking status of, 22
    comparing values, 2.8.4
    defining, 10, 10
    defining surrogates for, 10
    deleting, 10, 10
    in expressions, 2.4
    limiting, 16
    limiting to single value, 2.12.2
    looping over values of, 13, 13, 13
    maintaining, 16
    numeric value of text dimension, 2.6.3
    of expression, 2.5, 2.5.1
    order in models, 17
    QDR with, 2.12.2, 2.12.2.5
    related, 2.4.3.3
    restoring previous values, 5.2.4.3
    saving current values, 5.2.4.3
    See also alias dimensions, concat dimensions, conjoint dimensions, simple dimensions
    sorting values, 16
    statements for managing, A.3.15
    status lists, 22
    worksheet, 10
  dimensions, language, 6
  displaying error messages, 24
  DIVIDEBYZERO option, 2.6.6, 11
  division, 20
    by zero, 11
    calculating the remainder, 20
  DO command, 11, 13
    used with FOR, 13
    used with SWITCH, 23
    used with WHILE, 24
  DOEND command, 11
  double quotes (escape sequence), 2.2.2.2
  DSECONDS option, 11

## E

  ECHOPROMPT option, 5.4.3, 11
  EDIT command, 11
  editing previously executed commands, 20
  EIF file, 5.6.6, 12
    exporting data from, 12
    importing data from, 14
  EIFBYTES option, 11
  EIFEXTENSIONPATH option, 11
  EIFNAMES option, 11
  EIFSHORTNAMES option, 11
  EIFTYPES option, 11
  EIFUPDBYTES option, 11
  EIFVERSION option, 11
  encryption, 19
  END command, 11
  ENDDATE function, 11
  ENDOF function, 11
  EQ command, 11
  EQ operator, 2.3.2, 2.3.2, 2.3.2
  equations, dimension-based, 4.1
  ERRNAMES option, 11
  error messages, 21
    creating your own, 5.2.5.4
    deferring, 5.2.5.1
    displaying, 24
    finding line causing, 8
    option holding text of, 11
    output destination of, 11
    producing without error condition, 21
    signaling error condition, 21
    suppressing, 5.2.5.3, 9
    suppressing during compilation, 9
    wrapping, 24
  ERRORLOG statement, 7
  ERRORMASK statement, 7
  ERRORNAME option, 5.2.5, 11
  errors
    controlling during calculations, 2.6.6
    handling, 5.2.5
    handling in nested programs, 24, 24
    handling in programs, 24
    name of first-occurring error, 11
    recording line causing, 8
    signaling, 5.2.5.4, 24, 24
    when comparing numeric data, 2.8.3, 2.8.3.2, 2.8.3.3
  ERRORTEXT option, 5.2.5, 11
  escape character for LIKE, 15
  ESCAPEBASE option, 11
  events
    Assign, 24, 24
    assignment statements, 24
    Define, 24
    Delete, 24, 24
    deleting, 24, 24, 24
    identifying, 24
    Maintain, 24, 24
    Property, 24, 24
    Update, 24, 24, 24
  EVERSION function, 11
  EVERY function, 11
  EXISTS function, 11
  EXP function, 11
  exponential forecasting, 12, 13
  exponents, retrieving, 11
  EXPORT command, 5.6.6, 12
  EXPORT to EIF command, 12
  EXPORT to spreadsheet command, 12
  exporting data, 11, 11, 12
  expressions, 15
    ampersand substitution, 2.10
    Boolean, 2.3.2, 2.8, 2.9, 2.9
    changing dimensionality of, 9
    comparing, 18
    conditional, 2.9, 2.9
    data type of, 2.1.1
    dates in, 2.6.4
    defined, 2.1
    dimensions in, 2.4
    dimensions of, 2.5, 2.5.1
    formulas in, 2.4
    functions in, 2.4
    numeric, 2.6
    objects in, 2.4
    operators, 2.3.2
    padding, 16, 21
    parsing, 15, 19
    relations in, 2.4
    retrieving largest, 14
    retrieving smallest, 15
    saving, 10
    substitution, 2.10
    text, 2.7
    trimming, 16, 21
    using qualified data references in, 19
    using text dimension in numeric expression, 2.6.3
    valuesets in, 2.4
    variables in, 2.4
  EXPTRACE option, 12
  EXTBYTES function, 12
  EXTCHARS function, 12
  EXTCOLS function, 12
  external partitions, 9
  EXTLINES function, 12

## F

  fastest-varying dimension, 10
  FCCLOSE command, 12
  FCEXEC command, 12
  FCOPEN command, 12
  FCQUERY command, 12
  FCSET command, 12
  FETCH command
    See also SQL FETCH command
  fetching data (SQL), 22
  file I/O, 12, 12, 13, 13, 13, 13, 13
    closing, 12, 12, 12
    diagnosing errors when processing, 12
    forcing a page break, 13
    gathering information about, 13
    list of open files, 16
    opening, 13
    processing data from, 13
    reading a record, 13
    reading data from, 13
    reading Oracle OLAP commands from a file, 14, 15
    records read, 20
    setting attributes, 13
    writing, 13
  FILECLOSE command, 12
  FILECOPY command, 12
  FILEDELETE command, 12
  FILEERROR function, 12
  FILEGET function, 12
  FILEMOVE command, 12
  FILENEXT function, 13
  FILEOPEN function, 13
  FILEPAGE command, 13
  FILEPUT command, 13
  FILEQUERY function, 13
  FILEREAD command, 13
  files
    appending output, 19
    saving output in, 19
  FILESET command, 13
  fileunits, 13, 13
    attributes, 13
    number of outfile destination, 19
    opening, 13, 19
    reading data from, 13
    setting attributes, 13
  FILEVIEW command, 13
  FILTERLINES function, 13
  financial analysis, scenario modeling, 4.2.6
  financial functions, A.3.10.2
  FINDBYTES function, 13
  FINDCHARS function, 13
  FINDLINES function, 13
  FINTSCHED function, 13
  floating point numbers, comparing, 2.8.3.2
  floating-point format
    limitations when calculating, 2.6.5
    use of, 2.6.5
  FLOOR function, 13
  FOR command, 11, 13
    breaking out of, 8
    example of, 13
    looping over dimension values, 13, 13, 13
    used with BREAK, 8
    used with CONTINUE, 9
    used with OKFORLIMIT, 19
    used with TEMPSTAT, 23
  FORECAST command, 13
  forecast statements, A.3.11.1
  forecasting, 15
  forecasting context, 12
    closing, 12
    executing, 12
    obtaining information from, 15
    opening, 12
    querying, 12
    setting characteristics of, 12, 12
  FORECAST.REPORT program, 13
  form feed (escape sequence), 2.2.2.2
  formulas
    aggregating data with, 7
    compiling, 9, 9
    defining, 10, 10
    deleting, 10, 10
    recursive, 20
    specifying new expression, 11
    statements used for, A.3.16
  formulas in expressions, 2.4
  FPMTSCHED function, 13
  FULLDSC program, 13
  functions
    calling, 8
    in expressions, 2.4
    user-defined, 5.2.1, 5.2.1, 8, 21

## G

  GE operator, 2.3.2, 2.3.2, 2.3.2
  GET function, 14
  GOTO command, 14
  GREATEST function, 14
  group marker, 23
  GROUPINGID command, 14
  GROWRATE function, 14
  growth rate, 14
  GT operator, 2.3.2, 2.3.2, 2.3.2

## H

  handling errors in programs, 24
  hash partitions, 8
  heading, 14
    for a report, 14
    for output pages, 19
    including a page number, 19
    producing standard report heading, 23
  HEADING command, 14
  HIDE command, 14
  HIERCHECK program, 14
  HIERCHK.LOOPFND variable, 14
  HIERCHK.LOOPVALS variable, 14
  HIERCHK.XTRADIMS variable, 14
  HIERHEIGHT command, 14
  HIERHEIGHT function, 14
  Holt-Winters forecasting, 12, 13
  horizontal tab (escape sequence), 2.2.2.2
  hyperbolic cosine calculation, 9
  hyperbolic sine calculation, 21
  hyperbolic tangent calculation, 23

## I

  ID data type, 2.2.2
  IF command, 11, 14
  IFNONE keyword, 16
  IMPORT command, 5.6.6, 14
    See also SQL IMPORT command
  IMPORT from EIF command, 14
  IMPORT from spreadsheet, 14
  IMPORT from text command, 14
  importing data, 11, 11
    controlling update frequency, 11
    tracking names of objects, 11
    tracking types of objects, 11
  IN operator, 2.3.2, 2.3.2, 2.3.2
  INCLUDE command, 17
  INF_STOP_ON_ERROR option, 15
  INFILE command, 15
  INFO (FORECAST) function, 15
  INFO (MODEL) function, 15
  INFO (PARSE) function, 15
  INFO (REGRESS) function, 15
  INFO function, 15
    determining dimensionality with, 2.5.1
    DIMENSION keyword, 2.5.1
  INITCAP function, 15
  INLIST function, 15
  input file, 9
    debugging, 9
    finding line causing error, 8
    reading from a file, 14, 15
    with SNAPI connection, 14
    with XCA dialog, 14
  INSBYTES function, 15
  INSCHARS function, 15
  INSCOLS function, 15
  INSLINES function, 15
  INSTAT function, 15
  INSTR function, 15
  INSTRB function, 15
  INTEGER data type, 2.2.1
  integer part of decimal number, 15
  interest on loans, 13, 24
  internal partitions, 10
  internal rate of return, 15
  internationalization, 18
  INTPART function, 15
  IRR function, 15
  ISDATE program, 15
  ISSESSION function, 15
  ISVALUE function, 15

## J

  JOINBYTES function, 15
  JOINCHARS function, 15
  JOINCOLS function, 15
  joining
    columns of text, 15
    text columns, 15
  JOINLINES function, 15

## K

  KEY function, 15

## L

  label column width, 15
    branching in a program, 14
    for error handling in programs, 24
  labels, 14
    in programs, 5.2.5.6
    with IFNONE, 16
  LAG function, 2.6.4, 4.2.3, 15
  LAGABSPCT function, 15
  LAGDIF function, 15
  LAGPCT function, 15
  language dimension, 6
  larger value of two expressions, 16
  LARGEST function, 15
  largest value of an expression, 15
  LAST_DAY function, 15
  LCOLWIDTH option, 15
  LD command, 15
  LE operator, 2.3.2, 2.3.2, 2.3.2
  LEAD function, 2.6.4, 4.2.3, 15
  LEAST function, 15
  LIKE operator, 2.3.2, 2.3.2, 2.3.2, 2.8.6.1, 15, 15, 16
  LIKECASE option, 15
  LIKEESCAPE option, 15
  LIKENL option, 16
  LIMIT BASEDIMS command, 16
  LIMIT command, 16
    using LEVELREL, 16
    using NOCONVERT, 16
    using parent relation, 16
    using POSLIST, 16
    using related dimension, 16
    using values, 16
    with variables with composite, 2.4.4.3
  LIMIT function, 16
  limiting
    alias dimensions, 10
    dimensions, 16
    multidimensional valuesets, 10
  LIMITMAPINFO function, 16
  LIMIT.SORTREL option, 16
  LIMITSTRICT option, 16, 16
  line size for report heading, 16
  linefeed (escape sequence), 2.2.2.2
  LINENUM option, 16
  lines on a page of report output, 19
  LINESLEFT option, 16
  LISTBY program, 16
  LISTFILES command, 16
  LISTNAMES program, 16
  literals
    numeric, 2.2.1
    text, 2.7
  LOAD command, 16
  loans, 13
    interest payment on, 13
    interest payments on, 24
    payment on, 13
    payments on, 24
  local variables, 24, 24
  localization options, 18, A.2
  LOG command, 16
  LOG function, 16
  LOG10 function, 16
  logical operators, 2.3.2
  logs
    calculating base 10 logarithm, 16
    calculating natural logarithm, 16
  LONGINTEGER data type, 2.2.1
  LOOP clause in SQL FETCH, 22
  looping, 13
    over dimension status, 13
    statements, 5.2.3.1
  LOWCASE function, 16
  lowercase, converting to, 16
  LPAD function, 16
  LSIZE option, 16
  LT operator, 2.3.2, 2.3.2, 2.3.2
  LTRIM function, 16

## M

  MAINTAIN command
    event, 24, 24
    MAINTAIN ADD, 16
    MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER and YEAR values, 16
    MAINTAIN ADD for TEXT, ID, and INTEGER values, 16
    MAINTAIN ADD SESSION, 16
    MAINTAIN DELETE, 16, 16, 16
    MAINTAIN MERGE, 16
    MAINTAIN MOVE, 16
    MAINTAIN RENAME, 16
    trigger, 24, 24
  Maintain event, 24
  maintaining
    alias dimensions, 10
    composites, 16
    dimensions, 16
    partition templates, 16
    partitions, 16
  MAKEDATE function, 16
  margins, 8
    setting bottom margin, 8
    setting top margin, 23
  MAX function, 16
  MAXBYTES function, 17
  MAXCHARS function, 17
  MAXFETCH option, 17
  maximum values, 18
    for each time period in the status, 18
    larger of two expressions, 16
  MEASUREDIM statement
    for aggregation, 6
    for allocation, 7
  MEDIAN function, 17
  median value, 17
  messages, suppressing, 9
  MIN function, 17
  minimum value, 18
    for each time period in the status, 18
    smaller of two expressions, 17
  MMOF function, 17
  MODDAMP option, 17
  MODE function, 17
  models
    adding to aggmap, 6
    compiling, 4.3, 17
    creating, 17
    defined, 4.1
    defining, 10
    deleting, 10
    editing, 17
    in aggmap objects, 6
    removing from aggmap, 6, 6
    running, 4.4, 17
    scenario, 4.2.6
    solution variables, 4.1
  MODEL.XEQRPT program
    compiling, 9, 9
    debugging, 9, 17, 17
    defining, 10, 10
    finding line causing error, 8
    including, 17
    nesting, 17
    obtaining information about, 15
    options, 17, 17, 17, 17, 17, 17, 17, 17, 17
  MODERROR option, 17
  MODGAMMA option, 17
  MODINPUTORDER option, 17
  MODMAXITERS option, 17
  MODOVERFLOW option, 17
  MODSIMULTYPE option, 17
  MODTOLERANCE option, 17
  MODTRACE option, 17
  module version numbers, 11
  MONITOR command, 18
  monitoring, 18
    cost of program lines, 18
    cost of programs, 23
  MONTHABBRLEN option, 18
  MONTHNAMES option, 18
  MONTHS_BETWEEN function, 18
  MOVE command, 18
  MOVINGAVERAGE function, 18
  MOVINGMAX function, 18
  MOVINGMIN function, 18
  MOVINGTOTAL function, 18
  multidimensional valuesets, 10
  multiline text
    columns, 12, 15, 15, 20, 20
    counting lines in, 18
    deleting duplicate lines, 24
    extracting lines from, 12
    filtering lines in, 13
    finding lines, 13
    inserting lines into, 15
    joining, 15
    removing lines from, 20
    replacing lines in, 20
    sorting lines in, 21, 24
    testing whether found, 15
  MULTIPATHHIER option, 18
  multiwriter mode, 6, 8, 8, A.3.4

## N

  NA values
    accepted as numeric input, 18, 18
    caching, 24
    comparing, 2.8.2
    controlling how treated, 2.11.2, 2.11.2, A.2.12
    in Boolean expression, 2.8.2
    permanently replacing, 24
    replacing, 18
    replacing with strings, 18
    retrieving, 9
    spelling of, 18
    statements for working with, A.3.7
    substituting another value, 18
    triggers, 24, 24
  NAFILL function, 2.11.2, 2.11.2, 18, A.2.12
  name, 18
    changing object name, 20
    dimension, 18
    listing names of dictionary entries, 18
  NAME dimension, 18
  names
    listing for objects, 16
    listing objects by, 16
    qualified object, 2.4.1
  NASKIP option, 2.11.2, 2.11.2, 18, A.2.12
  NASKIP2 option, 2.11.2, 2.11.2, 18, A.2.12
  NASPELL option, 8, 18
  NATRIGGER
    See $NATRIGGER
  NATRIGGER property
    See $NATRIGGER property
  natural logarithm, 16
  NE operator, 2.3.2, 2.3.2, 2.3.2
  negative value, 19
    in output, 19
    obtaining the root, 21
  net present value, 18
  NEW_TIME function, 18
  NEXT_DAY function, 18
  NLS options, 18, A.2
  NLS_CALENDAR option, 18
  NLS_CURRENCY option, 18
  NLS_DATE_FORMAT option, 18
  NLS_DATE_LANGUAGE option, 18
  NLS_DUAL_CURRENCY option, 18
  NLS_ISO_CURRENCY option, 18
  NLS_LANG option, 18
  NLS_LANGUAGE option, 18
  NLS_NUMERIC_CHARACTERS option, 18
  NLS_SORT option, 2.8.6, 18
  NLS_TERRITORY option, 18
  NONE function, 18
  NORMAL function, 18
  NOSPELL option, 2.2.3, 18
  NOT operator, 2.3.2, 2.3.2, 2.3.2
  NPV function, 18
  NTEXT data type, 2.2.2
  null values
    See NA values
  NULLIF function, 18
  number conversion, 23, 23
  numbers
    assigning random numbers, 20
    commas in output, 9
    decimal marker for output, 10
    decimal places in output, 10
    determining sign of, 21
    negative values in output, 19
    rounding, 21
    thousands marker for output, 23
  NUMBYTES function, 18
  NUMCHARS function, 18
  numeric data types
    comparing, 2.8.3, 2.8.3.3
    list of, 2.2.1
    mixing, 2.6.1
  numeric expressions
    data type of the result, 2.6, 2.6.1
    dates in, 2.6.4
    defined, 2.6
    mixing data types in, 2.6.1
  numeric functions, A.3.10
  numeric options, A.3.10
  numeric values
    rounding, 21
  NUMLINES function, 18
  NVL function, 18
  NVL2 function, 18

## O

  OBJ function, 19
  object definitions
    adding descriptions to, 15
    deleting descriptions from, 15
    statements for manipulating, A.3.14
  objects, 2.4, 9
    assigning values to, 2.3, 2.3
    compiling, 9
    creating by copying, 9
    creating properties, 19
    defining, 10
    deleting, 10, 10
    describing its definition, 11
    describing its properties, 13
    dropping changes, 21, 21
    exporting from analytic workspace, 12
    identifying triggers, 24
    importing into analytic workspace, 14
    listing, 19
    listing names of, 16, 16, 18
    loading, 16
    making current, 9
    obtaining information, 19
    qualified name, 2.4.1
    recalculating permissions, 19
    renaming, 20
    restrictions on name, 10
    statements for defining, A.3.14
    statements for deleting, A.3.14
    testing for existence, 11
  OBJLIST function, 19
  OBSCURE function, 19
  obtaining, 15
    FORECAST results, 15
    model information, 15
    PARSE results, 15
    REGRESS results, 15
  OESEIFVERSION option
    name change, Preface
    See EIFVERSION option
  OKFORLIMIT option, 19
  OKNULLSTATUS option, 16, 19
  OLAP
    Data Definition Language See OLAP DML
    Data Manipulation Language See OLAP DML
  OLAP DML
    definition, 1.1
    functional categories, A.1
  OLAP DML SQL FETCH command, 22
  OLAP DML statements
    abbreviations, 5
  OLAP session cache
    blocking creation of, 21
    defined, 21
    populating with aggregated values, 6, 24
    populating with NA values, 24
  ONATTACH program, 19
  OPEN command See SQL OPEN command, 22
  operating system, identifying, 23
  operators, 15
    Boolean, 2.3.2, 2.3.2
    comparison, 2.3.2
    conditional, 2.9, 2.9
    LIKE, 15, 15
    logical, 2.3.2
    substitution, 2.10
    text formatting
      newline characters, 16
  options
    displaying value of, 1.2.1
    localization, 18
    NLS, 18
    restoring previous values, 5.2.4.3
    retrieving, 1.2.1
    saving current values, 5.2.4.3
    specifying, 1.2.1
  OR operator, 2.3.2, 2.3.2, 2.3.2
  OUTFILE command, 19, 19
  OUTFILEUNIT option, 19
  out-of-range decimal values, 10
  output, 19
    redirecting, 19
    saving in a file, 19
  overflow condition, 10

## P

  padding expressions, 16, 21
  PAGE command, 19
  PAGENUM option, 19
  PAGEPRG option, 19
  PAGESIZE, 19
  paging in reports, 19
    forcing a page break, 19
    line number on current page, 16
    lines for bottom margin, 8
    lines for top margin, 23
    lines left on page, 16
    lines on a page, 19
    page number, 19
    producing a custom heading, 19
    producing a standard heading, 23
    turning on, 19
  PAGING option, 19
  PARENS option, 19
  PARSE command, 2.5.1, 2.5.1, 19
  parsing expressions, 15, 19
  partition templates, 10, 10
    defining, 10, 10
    deleting, 10
    maintaining, 16
    retrieving partition names, 19
    retrieving partitioning method, 19
  PARTITIONCHECK function, 19
  partitioned variables, 10, 10
    aggregating, 7, 19
    defining, 10
    deleting data from, 16
    maintaining, 16
    retrieving dimensions of, 19
    retrieving partitioning method, 19
  partitioning methods, 19
  partitions, 10, 10
    adding, 9
    adding values to, 16, 16
    concat, 10
    defining, 10
      list partitions, 10
    deleting, 10
    deleting data, 16
    external, 7, 9, 10
    internal, 10
    list, 10
    locking segments of, 22
    moving values, 16
    range, 10, 19
    retrieving dimensions of, 19
    retrieving names of, 19
    specifying values of, 16
  pattern matching, 2.8.6.1
  payment schedules, 13
    for loan interest, 13, 24
    for loans, 13, 24
  PERCENTAGE function, 19
  permission
    programs, 5.6.1.1, A.3.18.5
  permission programs, 19, 19, 19
  permissions, 19
    assigning to an object definition, 19
    recalculating permission, 19
    specifying conditions for accessing, 19
    violations of, 19
  PERMIT command, 19
  PERMIT_READ program, 5.6.1.1, 19
  PERMIT_WRITE program, 5.6.1.1, 19
  PERMITERROR option, 19
  PERMITRESET command, 19
  platform, determining, 23
  POP command, 5.2.4.3, 5.2.4.4, 19, 19
    popping a whole series at once, 19
  POPLEVEL command, 19
    nesting, 19
    using, 5.2.4.5
  populating
    alias dimensions, 10
  POUTFILEUNIT option, 19
  PRECOMPUTE statement, 6
  PREPARE command
    See SQL PREPARE command
  PRGERR keyword (SIGNAL), 24
  PRGTRACE option, 19
  PROCEDURE statement
    See SQL PROCEDURE command, 22
  profiles, 23
  PROGRAM command, 19
  programs
    adding program contents to a definition, 19
    branching, 8, 9, 23
    branching in, 16
    branching labels, 14
    calling, 8
    case statement, 23
    comment lines in, 5.2
    compiling, 5.3, 5.3, 9, 9, 9
    conditional execution of commands, 14, 24
    debugging, 5.4, 8, 9, 12, 19
    declaring arguments in, 5.2.2.1
    defining, 10
    deleting, 10
    determining how invoked, 8, A.3.18.5
    error handling, 11, 11, 24
    errors in, 5.2.5
    executing, 5.5
    finding line causing error, 8
    halting execution with an error, 21
    hiding, 14
    local variable, 24
    passing arguments to, 8, 8, 8, 8
    performance cost, 23
    permission, 5.6.1, 5.6.1.1, 19, 19, 19, 19, 19, 19, A.3.18.5, A.3.18.5
    PERMIT_READ, 5.6.1.1
    PERMIT_WRITE, 5.6.1.1
    preserving environment, 5.2.4, 5.2.4
    preserving status, 9, 9, 19, 19, 19, 19
    repeating commands, 13
    restoring previous values, 5.2.4.3
    returning a value, 21
    running, 5.4
    saving compiled code, 5.3
    saving current values, 5.2.4.3
    startup, 5.6.1
    statements for, A.3.18
    suspending execution, 21
    terminating execution of, 21
    testing by running, 5.4
    timing execution, 18, 23
    trigger, 5.6.3.2, 24, 24, 24, 24, 24, 24, 24, 24
    unhiding, 24
  properties, 19
    copying with an object definition, 9
    creating for objects, 19
    listing for objects, 13
  PROPERTY command, 19
    event, 24, 24
    trigger, 24, 24
  Property event, 24
  PUSH command, 5.2.4.4, 19, 19
    marking start of series, 19
    placement, 5.2.5.6
    using, 5.2.4.3
  PUSHLEVEL command, 19
    nesting, 19
    placement, 5.2.5.6

## Q

  QDR
    with = command, 2.12.2.2
    with assignment statements, 2.12.2.2
  QUAL function, 2.12.2.7, 19
  qualified data references, 19
    ampersand substitution, 2.12.2.6
    creating, 2.12.2
    defined, 2.12.2
    qualifying a relation, 2.12.2.4
    replacing dimension of variable, 2.12.2.2, 2.12.2.3, 2.12.2.3
    using with relation, 2.12.2.4
    with = command, 2.12.2.2
    with assignment statement, 2.12.2.2
    with dimensions, 2.12.2
    with relations, 2.12.2.4
    with variables, 2.12.2.2, 2.12.2.2, 2.12.2.2, 2.12.2.3, 2.12.2.3
  qualified object name, 2.4.1
  quotation marks (escape sequence), 2.2.2.2

## R

  RANDOM function, 20
  random numbers, 18, 20
  random sparsity, 10
  RANDOM.SEED.1 option, 20
  RANDOM.SEED.2 option, 20
  range partitions, 10
    retrieving calculation for, 19
  RANK function, 20
  RANK_CALLS option, 20
  RANK_CELLS option, 20
  RANK_SORTS option, 20
  ranking
    performance monitoring, 20
  ranking performance monitoring, 20
  reading files, 20
    current record number, 20
    error diagnosis, 12
    FILEREAD command, 13
    processing a record, 13
    reading a record, 13
  RECAP command, 20
  RECNO function, 20
  RECURSIVE option, 20
  REDO command, 20
  REEDIT command, 20
  REGRESS command, 20
  regression, 12
    calculating a linear regression, 12, 20
    obtaining information about, 15
  regression statements, A.3.11.1
  REGRESS.REPORT program, 20
  related dimensions, 2.4.3.3
  relation, 23
  RELATION command, 20
  RELATION statement
    for aggregation, 6
    for allocation, 7
  relations
    assigning values to, 21, 21, 21
    comparing to text literals, 2.8.6.2
    default, 2.4.3.3, 20
    defining, 10, 10
    limiting to single value, 2.12.2.4
    QDR with, 2.12.2.4
    replacing dimension of, 2.12.2.4
  RELEASE command, 20
  REM function, 20
  remainder after division, 20
  REMBYTES function, 20
  REMCHARS function, 20
  REMCOLS function, 20
  REMLINES function, 20
  RENAME command, 20
  REPLBYTES function, 20
  REPLCHARS function, 20
  REPLCOLS function, 20
  REPLLINES, 20
  REPORT command, 20
  reporting, 20
  reports, 20, 21
    processing ROW command output, 21
    producing, 20
    producing with ROW commands, 21
  RESERVED function, 21
  reserved words, 21, 21
  restoring dimension status, 1.5.1.4
  RESYNC command, 21, A.3.4
  RETURN command, 21
  return value of a program, 21
  REVERT command, 21, 21
  ROLE option, 21
  roles, 23
  root of negative number, 21
  ROOTOFNEGATIVE option, 2.6.6, 21
  ROUND function, 2.8.3, 2.8.3.1
    for dates and time, 21
    for numbers, 21
  ROW command, 21
    processing output, 21
  ROW function, 21
  RPAD function, 21
  RTRIM function, 21
  running totals, 21, 24
  run-time aggregation, 3.1.3
  RUNTOTAL function, 21

## S

  saving dimension status, 1.5.1.4
  scenario models
    defined, 4.2.6
    for financial modeling, 4.2.6
  seasonal data, 12, 12
  SECONDS option, 21
  segment width, 9
  segments
    locking, 22
  SELECT statement
    See SQL SELECT command
  SELECT statements (in SQL), 22, 22
  selecting
    alias dimension values, 10
    data, 16
  SESSCACHE option, 21
  session cache
    See OLAP session cache
  sessions, 16
    preserving environment, 5.2.4, 5.2.4
    recording in disk file, 16
    restoring environment, 5.2.4.3
    user ID, 23
  SET command, 21
  SET1 command, 21
  SHORTDECIMAL data type, 2.8.3.3
  SHORTINTEGER data type, 2.2.1
  SHOW command, 21
  showing, 11
    definitions of workspace objects, 11
    names of objects, 16
    object names, 16
    object properties, 13
  SIGN function, 21
  SIGNAL command, 5.2.5.4, 21
  simultaneous equations in models, 4.2.5
  SIN function, 21
  sine calculation, 21, 21
  single quotes (escape sequence), 2.2.2.2
  SINH function, 21
  SLEEP command, 21
  slowest-varying dimension, 10
  smaller value of two expressions, 17
  SMALLEST function, 21
  smallest value of an expression, 21
  SMOOTH function, 21
  solution variables
    defined, 4.1
    example of, 17
  SORT
    command, 21
    function, 21
  SORTCOMPOSITE option, 21
  sorting
    dimension values, 16
    status list of a dimension, 16, 21, 21
    valuesets, 21, 21
  SORTLINES function, 21
  SOURCEVAL statement, 7
  sparse data, 15
    base dimension value, 15
    changing definitions, 9
    eliminating, 10
    exporting, 12
    importing, 14
    index algorithm, 21
    obtaining information, 19
    reading from files, 13
    renaming composites, 20
    reporting, 20, 21
    specifying composites, 10
    testing for a value, 15
  SPARSE keyword, 10
  SPARSEINDEX option, 21
  sparsity
    controlled, 10
    random, 10
  spreadsheets
    defining, 10
    exporting to, 12
    importing data from, 14, 14
    See worksheets
  SQL CLEANUP command, 22
  SQL CLOSE command, 22
  SQL command, 22
  SQL DECLARE CURSOR command, 22
  SQL EXECUTE command, 22
  SQL IMPORT command, 22
  SQL PREPARE command, 22
  SQL PROCEDURE command, 22
  SQL SELECT command, 22, 22
  SQL statements, 22
    compiling, 22
    embedding in OLAP DML, 5.6.2.1, 22
    optimizing, 22
  SQL stored procedures
    creating, 22
    executing, 22
  SQL support, 22
    blocking factor, 22
    error codes, 22
    error messages, 22, 22
    SQL statement execution, 22
  SQLBLOCKMAX option, 22
  SQLCODE option, 22
  SQLCOLUMNS procedure, 22, 22
  SQLERRM option, 22
  SQLFETCH function, 22
  SQLMESSAGES option, 22
  SQLTABLES procedure, 22, 22, 22
  SQRT command, 22
  square root, 22
    calculating, 22
    result for negative number, 21
  standard deviation calculation, 23
  STARTOF function, 22
  startup programs, 5.6.1
  STATALL function, 22
  STATDEPTH function, 22
  statements
    abbreviating, 5
    altering order of execution, 14
    editing previously executed, 20
    functional categories of, A
    looping, 5.2.3.1
    reading from a file, 15
    sending to file, 20
  STATFIRST function, 22
  STATIC_SESSION_LANGUAGE option, 22
  statistical functions, A.3.10.3
  STATLAST function, 22
  STATLEN function, 22
  STATLIST function, 22
  STATMAX function, 22
  STATMIN function, 22
  STATRANK function, 22
  status, 22, 22
    checking current status list, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22
    checking for a dimension value, 15
    dimension, 22
    looping over in a program, 13, 19, 23
    null values, 19
    saving, 9, 9, 19, 19, 19, 19
    See dimension status
    setting, 16
    sorting values in the status list, 21, 21
    using result of LIMIT command, 16
  status list
    current, 1.5.1.1
    default, 1.5.1.2
    empty, 19
  STATUS program, 22
  STATVAL function, 22
  STDDEV function, 23
  STDHDR program, 23
    line size for centering, 16
  storage, 9
    in-place vs. permanent, 9
    of variables, 10
  stored procedures
    creating, 22
    executing, 22
  STORETRIGGERVAL property, 19
    See $STORETRIGGERVAL property
  subevents, identifying, 24
  substitution expressions, 2.10
  substitution operator, 2.10
  SUBSTR function, 23
  SUBSTRB function, 23
  substrings
    retrieving, 15, 15, 23, 23
  SUBTOTAL function, 23
  subtotals, 23
    in a report, 23
    resetting to zero, 24
  surrogate dimension, 10
    defining, 10
  surrogates
    defining, 10
    deleting, 10
  SWITCH command, 8, 11, 23
  SYSDATE function, 23
  SYSINFO function, 23
  SYSTEM function, 23
  system statements, A.3.1

## T

  tab (escape sequence), 2.2.2.2
  TALLY function, 23
  TAN function, 23
  tangent calculation, 23
    arc, 8, 8
    hyperbolic, 23
  tangents
    calculating angle value, 8
  TANH function, 23
  TCONVERT function, 23
  temporary members
    adding to dimension, 16
    identifying, 15
  TEMPSTAT command, 23
  testing
    if every value is true, 11
    if no values are true, 18
    number of true values, 9
    whether an object exists, 11
  text, 15
    comparing values, 2.8.6, 2.8.6
    comparing values to a pattern, 2.8.6.1
    data types, 2.2.2
    functions, A.3.8.1, A.3.8.2, A.3.8.3
    multiline, 8
    NLS_SORT option in comparisons, 2.8.6
    options, A.3.8.1, A.3.8.2, A.3.8.3
    passing arguments as, 5.2.2.3, 16
    See also multiline text
  TEXT data type, 2.2.2
  text expressions, 2.7, 2.7.2
  text formatting, 23
    case sensitivity, 15
    changing part of a text value, 8, 8
    comparing lines to master list, 15
    converting to uppercase, 24
    counting lines in a value, 18
    deleting duplicate lines, 24
    extracting lines, 12
    extracting part of a text value, 12, 12, 12
    filtering lines, 13
    finding bytes, 13
    finding characters, 13
    finding position of lines in a value, 13
    importing worksheet data, 14
    inserting a text value, 15
    inserting bytes into a text value, 15
    inserting characters into a text value, 15
    inserting lines, 15
    joining, 8
    joining columns of values, 15
    joining in one line, 15, 15
    joining lines, 15
    number of bytes in, 17, 18
    number of characters in, 17, 18
    reformatting, 23
    removing lines, 20
    removing part of a text value, 20, 20, 20
    replacing lines, 20
    replacing part of a text value, 20, 20, 20
    sorting lines in a multiline value, 21, 24
    stripping blank spaces from, 8
  text literals
    comparing to relations, 2.8.6.2
    defined, 2.7
  TEXTFILL function, 23
  thousands marker, 23
  THOUSANDSCHAR option, 23
  time, 18
  time functions, A.3.9
  time of day, 23, 23
  time series, 15
    averaging over, 18
    cumulative totals over, 9
    data from previous time period, 15
    data from subsequent time period, 15
    difference between time periods, 15
    maximum value in period, 18
    minimum value in period, 18
    moving totals over, 18
    percent difference between time periods, 15, 15
  time-series functions, A.3.10.4
  timing, 18
    execution of program lines, 18
    execution of programs, 23
  title for a report, 14
  TMARGIN option, 23
  TO_CHAR function, 23
  TO_DATE function, 23
  TO_NCHAR function, 23
  TO_NUMBER function, 23
  TOD function, 23
  TODAY function, 23
  TOTAL function, 23
  totals
    calculating, 23
    cumulative, 9
    in a report, 20, 21, 21, 23
    moving, 18
    over time, 18
    running, 21
  TRACEFILEUNIT option, 23
  tracking, 18
    cost of program lines, 18
    cost of programs, 23
  TRACKPRG command, 23
  TRACKREPORT program, 23
  transferring, 24
    data, 24
  TRAP command, 5.2.5.1, 24, 24, 24, 24
  TRIGGER command, 24
  TRIGGER function, 24
  trigger objects, 24
  trigger programs
    Assign, 24, 24
    Delete, 24, 24
    designing, 5.6.3.2
    Maintain, 24, 24
    Property, 24, 24
    Update, 24
    update, 24
  TRIGGER_AFTER_UPDATE program, 24
  TRIGGER_AW program, 24, 24
  TRIGGER_BEFORE_UPDATE program, 24
  TRIGGER_DEFINE program, 24
  TRIGGERASSIGN command, 24
  TRIGGERMAXDEPTH option, 24
  triggers
    Assign, 24, 24
    creating, 24
    Define, 24
    Delete, 24
    deleting, 24, 24, 24
    events, 24
    Maintain, 24
    NA, 6, 24, 24
    objects, 24
    Property, 24
    subevents, 24
    Update, 24, 24, 24
  TRIGGERSTOREOK option, 24
  TRIM function, 24
  trimming expressions, 16, 21
  trimming strings, 24
  TRUNC function, 24
    for dates and time, 24
    for numbers, 24

## U

  UNHIDE command, 24
  UNIQUELINES function, 24
  unnamed composites, 10
    defining, 10
    example of, 10
  UNRAVEL function, 24
  UPCASE function, 24
  UPDATE command, 24
    event, 24
    events, 24, 24
    trigger, 24
    triggers, 24, 24, 24
  uppercase, converting to, 24
  user ID, 23
  user-defined functions
    arguments in, 5.2.1
    data type of, 5.2.1
  USERID option, 24
  USETRIGGERS option, 24

## V

  VALSPERPAGE program, 24
  value name format, 24
    See also VNF command
  values
    assigning to objects, 2.3
    restoring previous, 5.2.4.3
    saving current, 5.2.4.3
  VALUES function, 24
  VALUESET statement, 7
  valuesets
    assigning values to, 10
    checking, 15
    checking current status list, 22, 22, 22, 22, 22, 22, 22, 22, 22
    defining, 10, 10
    deleting, 10
    limiting, 10
    listing values, 24
    multidimensional, 10
    null, 19
    setting the status of, 16
    sorting values, 21, 21
  VARCACHE option, 24
  VARCACHE property
    See $VARCACHE property
  VARIABLE command, 24
  variables
    accessing, 2.4.4.2
    adding partition, 9
    Aggcount, 6, 9, 10, 10
    assigning values to, 21
    defining, 10, 10
    defining in a program, 5.3.2
    defining with composite, 10
    defining with unnamed composite, 10
    deleting, 10
    how data is stored, 10
    limiting to single value, 2.12.2.2, 2.12.2.2, 2.12.2.2, 2.12.2.3, 2.12.2.3
    local to a program, 24
    partitioned, 7, 10, 10, 10
    QDR with, 2.12.2.2, 2.12.2.2, 2.12.2.2, 2.12.2.3, 2.12.2.3
    replacing dimension of, 2.12.2.2, 2.12.2.3, 2.12.2.3
    reshaping dimensionality of, 19
    sparse data in, 2.4.4.3
    storage of, 10
  version, 11
  VINTSCHED function, 24
  VNF
    See value name format
  VNF command, 24
  VPMTSCHED function, 24

## W

  WEEKDAYSNEWYEAR option, 24
  WEEKOF function, 24
  WHILE command, 8, 24
    used with BREAK, 8
    used with CONTINUE, 9
  WIDTH_BUCKET function, 24
  wildcards, 2.8.6.1, 2.8.6.1
  WKSDATA function, 24
  WORKSHEET data type, 2.2
  worksheet objects
    cells, 24
    data type of cells, 24
    defining, 10, 10, 10
    deleting, 10
    dimensions, 10
  workspace aliases, 2.4.1
  WRAPERRORS option, 24

## Y

  YESSPELL option, 2.2.3, 24
  YRABSTART option, 24
  YYOF function, 24

## Z

  zero, 11
    dividing by, 2.6.6, 11
    spelling of, 24
    suppressing all-zero report rows, 24
  ZEROROW option, 24
  ZEROTOTAL command, 24
  ZSPELL option, 24